
---------------------------------------+
| s1    | CREATE SEQUENCE `s1` start with 1005 minvalue 10 maxvalue 2000
increment by 1 cache 1000 nocycle ENGINE=Aria |
+-------+----------------------------------------------------------------------
---------------------------------------+

Notes
-----

ALTER SEQUENCE will instantly affect all future SEQUENCE operations. This is
in contrast to some other databases where the changes requested by ALTER
SEQUENCE will not be seen until the sequence cache has run out.

ALTER SEQUENCE will take a full table lock of the sequence object during its
(brief) operation. This ensures that ALTER SEQUENCE is replicated correctly.
If you only want to set the next sequence value to a higher value than
current, then you should use SETVAL() instead, as this is not blocking.

If you want to change storage engine, sequence comment or rename the sequence,
you can use ALTER TABLE for this.

URL: https://mariadb.com/kb/en/alter-sequence/