How to do first order by then sort using sql query?

Question

This is my query:=  select * from (select Questions from Tble_Questions ORDER BY Questions)A WHERE A.Questions between 1 and 10

 

 

Error: The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions, unless TOP or FOR XML is also specified.