MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select version();


version()


8.0.30


create table orders (id int not null auto_increment primary key, product int not null);
insert into orders(product)
with recursive cte as (
  select 1 as x
  union all
  select x+1 from cte where x<100
  )
select * from cte;

Records: 100  Duplicates: 0  Warnings: 0


-- AUTO_INCREMENT= (is not 100)
show create table orders;


Table
Create Table


orders
CREATE TABLE `orders` (
  `id` int NOT NULL AUTO_INCREMENT,
  `product` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=128 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci


select max(id) from orders;


max(id)


100


insert into orders(product)
with recursive cte as (
  select 1 as x
  union all
  select x+1 from cte where x<100
  )
select * from cte;

Records: 100  Duplicates: 0  Warnings: 0


select *
from (
select 
  id,
  lead(id) over (order by id) nextValue
from orders) x
where abs(nextValue - id)<>1;


id
nextValue


100
128