MySQL - Setup an auto-incrementing primary key that starts at 1001:

Step 1, create your table:

create table penguins(
  my_id       int(16) auto_increment, 
  skipper     varchar(4000),
  PRIMARY KEY (my_id)
)

Step 2, set the start number for auto increment primary key:

ALTER TABLE penguins AUTO_INCREMENT=1001;

Step 3, insert some rows:

insert into penguins (skipper) values("We need more power!");
insert into penguins (skipper) values("Time to fire up");
insert into penguins (skipper) values("kowalski's nuclear reactor.");

Step 4, interpret the output:

select * from penguins

prints:

'1001', 'We need more power!'
'1002', 'Time to fire up'
'1003', 'kowalski\'s nuclear reactor'

MySQL Workbench

If you want to avoid writing sql, you can also do it in MySQL Workbench by right clicking on the table, choose "Alter Table ..." in the menu.

When the table structure view opens, go to tab "Options" (on the lower bottom of the view), and set "Auto Increment" field to the value of the next autoincrement number.

Don't forget to hit "Apply" when you are done with all changes.

PhpMyAdmin:

If you are using phpMyAdmin, you can click on the table in the lefthand navigation, go to the tab "Operations" and under Table Options change the AUTO_INCREMENT value and click OK.

With CREATE TABLE statement

CREATE TABLE my_table (
  id INT UNSIGNED NOT NULL AUTO_INCREMENT,
  name VARCHAR(100) NOT NULL,
  PRIMARY KEY (id)
) AUTO_INCREMENT = 100;

or with ALTER TABLE statement

ALTER TABLE my_table AUTO_INCREMENT = 200;

First you need to add column for auto increment

alter table users add column id int(5) NOT NULL AUTO_INCREMENT FIRST

This query for add column at first. Now you have to reset auto increment initial value. So use this query

alter table users AUTO_INCREMENT=1001

Now your table started with 1001

You could also set it in the create table statement.

`CREATE TABLE(...) AUTO_INCREMENT=1000`

Alternatively, If you are too lazy to write the SQL query. Then this solution is for you.

1. Open phpMyAdmin
2. Select desired Table
3. Click on Operations tab
4. Set your desired initial Value for AUTO_INCREMENT
5. Done..!

For this you have to set AUTO_INCREMENT value

ALTER TABLE tablename AUTO_INCREMENT = <INITIAL_VALUE>

Example

ALTER TABLE tablename AUTO_INCREMENT = 101

Also , in PHPMyAdmin , you can select table from left side(list of tables) then do this by going there.
Operations Tab->Table Options->AUTO_INCREMENT.

Now, Set your values and then press Go under the Table Options Box.

SET GLOBAL auto_increment_offset=1;

SET GLOBAL auto_increment_increment=5;

auto_increment_increment: interval between successive column values

auto_increment_offset: determines the starting point for the AUTO_INCREMENT column value. The default value is 1.

read more here

Single statement on existing data (MySQL 8.0)

Assuming you already have an id column (of the default INT type^[3]), here’s how to set it as the primary key with a next increment of 1001:

ALTER TABLE `users`

    -- 1. Set the auto-increment value, before anything uses it
    AUTO_INCREMENT=1001,
    
    -- 2. Set the column's default value, before it is constrained
    CHANGE COLUMN `id` 
        `id` INT
            NOT NULL AUTO_INCREMENT FIRST,
        
    -- 3. Add the constraint the MySQL way
    ADD PRIMARY KEY (`id`)
;

Notes

1. If your id column contains a duplicate value, it should fail, throwing SQL error 1062, including a message telling you which value is duplicated.

2. As others have noted, auto-increment will use the highest existing value + 1 by default. Explicitly setting a high auto-increment value is unnecessary if the only reason is to prevent duplicate values.

3. If your id column is defined differently, know that the CHANGE COLUMN operation requires the whole column definition be entered, as though it were being created for the first time. Alter step 2's second line to match the name and type of your existing column. (For example, Laravel's id column type is BIGINT UNSIGNED.)

4. Tested using MariaDB 10.11.10, HeidiSQL 12.8.0.6908, and MySQL 8.0.30. Credit to HeidiSQL's implementation and handy “ALTER code” table tab for the correct sequence.