column value is not increment after 10
I think you have your column data-type on non numeric format. if your data type is CHAR (or VARCHAR) type it would select 9 as your max number.

If you change your datatype for the column to INT, your problem should be resolved.