Amir's answer is enough but here alternative solution
Add an another column in your table(Ex. Default or DisplayOrder), see below table.
ID Name IsDefault
-----------------
1 INR N
2 USD N
3 SGD Y
4 EURO N
Use the Below Query
SELECT * FROM [Table] ORDER BY SGD DESC
ID Name DisplayOrder
-----------------
1 INR 2
2 USD 3
3 SGD 1
4 EURO 4
SELECT * FROM [Table] ORDER BY DisplayOrder