Skipping order id by 1 in Magento 2

After digging into the some articles I figured out, there is no other way to make increment by 2 than this:

Magento stores order auto increment id in sequence_order_1 or sequence_order_2 table, based on stores. So it uses only 1 increment id by default. Unless someone change auto_increment_increment value of database like:

SET @@auto_increment_increment=2;

Try this command and see if your auto increment value is fixed:

SET @@auto_increment_increment=1;

I didn't find any other solution.

Note: If you are getting this issue on order increment id and it is occurring due to auto increment value, then it would be occurring on all tables, because it's a global variable

Just wanted to help :)


Do check the value of step column in sales_sequence_profile table for meta_id (5 might be different but you need to check for the order one)