with req as (
               select p as pp, gc.name d
                 from tbl_list t,
                       lateral(
                                 select  t.no_beg + level - 1 p
                                 from  dual
                                 where t.no_beg is not null and t.no_end is not null
                                 connect by t.no_beg + level - 1 <= t.no_end
                               ),
                       tbl_group gc       
                where t.group = gc.id and 
                      p between 1 and 100
                order by gc.name, p      
              )   
  select  listagg(case 
                    when ROWNUM = 6 then 'и другие'
                    when ROWNUM > 6 then null  
                  else  
                    req.pp ||'('||req.d||')'
                  end,
                  ', ') within group(order by to_number(req.pp)) 
  from req;