Select
 i,
 min(case when j > 0 then k * 1000 + i end) over (order by k rows between 1 following and unbounded following) % 1000
from @t a
Order by k ASC

Declare @t table (i int, j int, k int identity (1,1), g uniqueidentifier default newid())

insert into @t (i,j)
Values (1, 1), (3, 1), (2, 1), (4, 0), (6, 1), (5, 0), (9, 0),  (7, 1), (8, 0), (10, 1), (11, 0)

Select
 i, g,
 min(case when j > 0 then k * 1000 + i end) over (order by k rows between 1 following and unbounded following) % 1000,
 cast(substring(min(case when j > 0 then str(k, 10) + cast(g as varchar(36)) end) over (order by k rows between 1 following and unbounded following), 11, 100000) as uniqueidentifier)
from @t a
Order by k ASC