How to add auto-increment column in MySQL table with some particular number? -

i want add new primary key auto-incremented column alter command don't want start 1.

note: table has data other columns want add new-column starts auto increment number other 1.

so there way achieve alter command add column.

this can done

alter table my_table auto_increment = 1000  alter table my_table add my_table_id int primary key auto_increment first;