all ids are incrementing together in h2 code example
Example: h2 auto increment and unique
drop table test;
create table test(id bigint auto_increment, name varchar(255));
insert into test(name) values('hello');
insert into test(name) values('world');
select * from test;