SQL Server 2017

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table YourTable 
(
Id int primary key identity(1,1) not null,
F1 varchar(30),
F2 int,
Ref_ID int,
foreign key (Ref_ID) references YourTable(Id)
);
insert into YourTable (F1, F2) values
('Arian',   5),
('Ava',     1),
('Arsha',   3),
('Rozhan', 30),
('Zhina',  20),
('Nima',   35),
('Eli',    33);
7 rows affected

update YourTable set Ref_ID = (select top 1 Id from YourTable where F1 = 'Nima')
where F1 in ('Arian','Ava','Rozhan');

update YourTable set Ref_ID = (select top 1 Id from YourTable where F1 = 'Eli')
where F1 in ('Arsha','Zhina');
5 rows affected

SELECT Id, F1, F2, Ref_ID
FROM YourTable
ORDER BY COALESCE(Ref_ID, Id), IIF(Ref_ID IS NULL, 0, 1), Id;


Id
F1
F2
Ref_ID


6
Nima
35
null

1
Arian
5
6

2
Ava
1
6

4
Rozhan
30
6

7
Eli
33
null

3
Arsha
3
7

5
Zhina
20
7

Id	F1	F2	Ref_ID
6	Nima	35	null
1	Arian	5	6
2	Ava	1	6
4	Rozhan	30	6
7	Eli	33	null
3	Arsha	3	7
5	Zhina	20	7