Get current value from a SQL Server SEQUENCE

You can select the current_value from sys.sequences:

SELECT current_value FROM sys.sequences WHERE name="OrderNumberSequence" ;

DEMO