MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table test (id int unsigned not null auto_increment primary key, 
                   val int) engine=InnoDB auto_increment=1;
insert into test (val) values (11),(22),(33);
ALTER TABLE test AUTO_INCREMENT=7;
insert into test (val) values (44),(55),(66);
insert into test (id, val) values (4,444),(5,555),(6,666);
insert into test (val) values (77),(88),(99);
SELECT * FROM test;


id
val


1
11

2
22

3
33

4
444

5
555

6
666

7
44

8
55

9
66

10
77

11
88

12
99