sql - Auto incrementing ID value -

I have an HSQLDB database with a Generated ID and I want to automatically increase the incremental value to 100,000. Is it possible with HSQLDB? Is it possible with any database? According to

:

Since 1.7.2, SQL The standard syntax is used by default, which allows to specify the initial value. Is a supported form (INTEGER generated by default as the identifier (with start, n, [M $ by INR]) primary key, ...). Support for BIGINT identity columns has also been added. As a result, an identity column is a default or regular column generated by a sequence generator.

...

The next identity value can be set with

  ALTER TABLE ALTER COLUMN & Lt; Column name & gt; & Lt; New Value & gt;