MySQL 8.0

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

create table test (id smallint not null auto_increment primary key, val int) auto_increment=32765
insert into test (val) values (1),(2)
insert into test (val) values (3),(4)

Failed to read auto-increment value from storage engine

insert into test (val) values (5)
insert into test (val) values (6)

Duplicate entry '32767' for key 'test.PRIMARY'

select * from test

id
val

32765
1

32766
2

32767
5