I think this query works:
select NameT1 = o.name, NameT2 = e.name
from
(
select *, t=(sequence_no-1)/2
from Table_Check
where sequence_no%2<>0
) o inner join
(
select *, t=(sequence_no-1)/2
from Table_Check
where sequence_no%2=0
) e on e.t = o.t
But it is not a nice one!