Provide a variable for the default cache size for create sequence

Sequences has a default cache value of 1000.
This task is to provide a system variable for the default cache size when creating a sequence. This variable should also be written to the binary log or optionally we should add CACHE=... to the CREATE SEQUENCE statement in the binary log if the variable is used.

This is useful for users that would like MariaDB to behave more like PostgreSQL and/or want to avoid some gaps in the generated sequence.

Note that having a cache of 1 instead of 1000, can make inserts into tables using sequences 2x slower and the binary log to take up 7x more space!
See the comments in MDEV-30865 for some more information.