how to generate ordered sequence for n number of n number of child

select <>

from yourtable order by isnull(parentid, id), id;