Solution for SQL Server to use ROW_NUMBER without sorting

Set SQL Server to use ROW_NUMBER without sorting

-- 1. We can see that nhib.pdf is a page written in this way, and it feels easier to write (should it be less efficient ?)
-- With is just an alias?

[SQL]
With query as (select ROW_NUMBER () over (order by (select 0) as rownum, * FROM Product)
Select * from query where rownum between 5 AND 10

-- 2. ROW_NUMBER must specify the write over (order by **). Sometimes I don't want to sort it at all and want to sort it in the original order (it also takes time to sort it)

-- The method is:
Select ROW_NUMBER () over (order by (select 0) as rownum, * FROM Product

Sorting is:
Select Row_number () over (order by Oper_Date desc) as rownum, * FROM Product