select id ，name from user where id in(1,3,2,4)  order by case when 1 then 1 when 3 then 2 when 2 then 3 when 4 then 4 end
--try

------解决方案--------------------
前后都加引号
避免1 12 这种。
SQL code
select id ,name from user where id in(1,3,2,4)   
order by charindex( ','+ltrim(id)+',' ,',1,3,2,4,')

------解决方案--------------------
SQL code

select name,number from master..spt_values  where number in(1,2,3,4) and type='p'
order by case when number=1 then 1 
when number=3 then 2 when number=2 then 3 when number=4 then 4 end

/*
name                                number
----------------------------------- -----------
NULL                                1
NULL                                3
NULL                                2
NULL                                4

(4 行受影响)
*/

------解决方案--------------------
select id ,name from user where id in(1,3,2,4)   order by (id+1)%2,id  


------解决方案--------------------
SQL code
select
   id ,name 
from [user] where id in(1,3,2,4)   
order by charindex( ','+ltrim(id)+',' ,',1,3,2,4,')