set column autogenerate numbers

Question

i have a table with column student_id as primary key, also i have another column which is student admission number i want after every registration adm_no to move to next number without skipping , how can i do it