CREATE TABLE t1

(

id INT NOT NULL auto_increment,

PRIMARY KEY (id),

name VARCHAR(30)

) ENGINE=MyISAM;

INSERT into t1(name) values('Record_1');

SELECT * from t1;

--echo ## Changing value of variable to 10 ##

SET @@session.auto_increment_increment = 10;

INSERT into t1(name) values('Record_2');

SELECT * from t1;

ALTER table t1 MODIFY id SMALLINT NOT NULL auto_increment;

INSERT into t1(name) values('Record_3');

SELECT * from t1;

MariaDB [test]> SELECT * from t1;

+----+----------+

| id | name     |

+----+----------+

|  1 | Record_1 |

| 11 | Record_2 |

| 12 | Record_3 |

+----+----------+

3 rows in set (0.00 sec)

MariaDB [test]> SELECT * from t1;

+----+----------+

| id | name     |

+----+----------+

|  1 | Record_1 |

| 11 | Record_2 |

| 21 | Record_3 |

+----+----------+

3 rows in set (0.00 sec)