I went here when I had the problem. Is there any way around this (ie. assign a default)? Or am I just gonna have to live with it?
After creating your table you can then set the default value with
alter table subsites Auto_Increment=100;
Tested and working on 4.1.7
