Add a column for your exceptions (1,2,10) rows and set a sort order number in that column, then query as follows:
select * from [table] where [exception] > 0 order by [exceptions]
union
select * from [table] where [exception] = 0 order by [name]
EDIT :
select * from [table] where pk_id in (1,2,10)
union
select * from [table] where pk_id not in (1,2,10) order by [name]