You will need to make use of Temp Table to get this output
--Generating Sample data
declare @tbl Table(Id int, Dept varchar(30))
insert into @tbl
select
14, 'Academy'
union all
select
1, 'Administrator'
union all
select
4, 'Advertising Dept'
union all
select
21, 'All'
union all
select
17, 'Exporting Dept'
union all
select
6, 'Finance Dept'
union all
select
13, 'HR Dept'
union all
select
3, 'IT Dept'
union all
select
20, 'Production Dept'
union all
select
18, 'Purchasing Dept'
union all
select
19, 'Research and development Dept'
union all
select
16, 'Sales Dept'
union all
select
15, 'Technical support Dept'
---Actual Query Starts here
declare @Table Table([auto] int IDENTITY(1,1) NOT NULL, Id int, Dept varchar (30))
insert into @Table
select Id, Dept from @tbl where Id = 21
insert into @Table
select Id, Dept from @tbl where Id <> 21
order by Dept Asc
Select Id, Dept from @Table order by [auto]
