Welcome in 2022 (version of SQL Server). We can generate a series of numbers within a given interval and step between series values with GENERATE_SERIES function:
GENERATE_SERIES
SELECT * FROM GENERATE_SERIES(1, 10000);
Source: https://learn.microsoft.com/en-us/sql/t-sql/functions/generate-series-transact-sql?view=sql-server-ver16