Try this code block.
SELECT [ORDER] FROM (
SELECT CASE WHEN [ORDER] = 3 THEN 0 ELSE 1 END ROWNUM,[ORDER] FROM Orders
)A ORDER BY ROWNUM,[ORDER]
If you want to test this query then please run the following whole code block at once
WITH Orders AS
(
SELECT 1 [ORDER]
UNION ALL
SELECT [ORDER] + 1 FROM Orders WHERE [ORDER] < 10
)
SELECT [ORDER] FROM (
SELECT CASE WHEN [ORDER] = 3 THEN 0 ELSE 1 END ROWNUM,[ORDER] FROM Orders
)A ORDER BY ROWNUM,[ORDER]
Thank you