You can use a custom sort by clause in your query.
For example
SELECT Column1, Column2
FROM dbo.Country
ORDER BY CASE WHEN Status = 6 THEN 1
WHEN Status = 5 THEN 2
ELSE Status END ASC
For more detailed information please check this
link[
^].
Good luck,
OI