Is it possible to create a table with two autoincrement fields?

Question

SQL Server

There is a table:

create tabel order (
   Id int IDENTITY(1,1) NOT NULL,
   Number int NOT NULL
)

Question: How can I make the "Number" field auto-increment? It is clear that one table cannot have more than one auto-increment field, but perhaps there are some workarounds?
It seems that in the new versions of Microsoft SQL Server there are so-called "Sequences", with the help of which the problem is solved.
If we exclude this option, what are the best practices for solving this problem?

Answer 1

CREATE SEQUENCE?