Order by clause - excluding one value

Question

Hi,

 

I need to order the result with the following data. Where 678 record should be on top and remaining should be as order by condition.

 

 Id

100

200

678

678 

875

900

678

ORDER BY ID DESC 

 Result should be as follows

678

678

678

900

875

200

100