Sqlserver中根据in的顺序排序

Question

select ptp.id from [dbo].[Pic_Temp_Process] ptp where ptp.id in (5599, 1763317, 1130129, 505992, 174477, 23565, 1192438) order by charindex(','+convert(varchar,ptp.id)+',',',5599, 1763317, 1130129, 505992, 174477, 23565, 1192438,')我的语句5599, 1763317, 1130129, 505992, 174477, 23565, 1192438顺序应该是按这样子但实际返回给我请问in的排序sql怎样写，谢谢！