I have 2 tables order\_retailer and order\_customer

they both have auto incremented primary key order\_id

To keep an order id unique in the whole system I want order\_retailer to have id as even numbers only and for order\_customer the ids will be odd. For this I have to set the autoincrement's increment value to 2. is it possible to set it table wise in mysql.

I don't want a php solution. please let me know if there is a command/query to set the auto increment shift to 2 for a perticular table.
Also I don't want to change the server variables auto\_increment\_increment or auto\_increment\_offset or any other server variable