MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table class_room(
    section varchar(20),
    section_name varchar(20),
    section_id varchar(20),
    student_rollno varchar(20)
);
insert into class_room values ('A','DIV A','01','547');
insert into class_room values ('A','DIV A','01','548');
insert into class_room values ('A','DIV A','01','549');
insert into class_room values ('A','DIV A','01','550');
insert into class_room values ('A','DIV A','01','551');
insert into class_room values ('A','DIV A','01','552');
insert into class_room values ('A','DIV A','01','567');
insert into class_room values ('A','DIV A','01','568');
insert into class_room values ('A','DIV A','01','593');
insert into class_room values ('A','DIV A','01','594');
insert into class_room values ('A','DIV A','01','595');
insert into class_room values ('A','DIV A','01','596');
insert into class_room values ('A','DIV A','01','597');
insert into class_room values ('A','DIV A','01','598');
select section, section_name, section_id, min(student_rollno), max(student_rollno)
from (select cr.*,
             row_number() over (partition by section, section_name, section_id order by student_rollno) as seqnum
      from class_room cr
     ) cr
group by section, section_name, section_id, (student_rollno - seqnum)


section
section_name
section_id
min(student_rollno)
max(student_rollno)


A
DIV A
01
547
552

A
DIV A
01
567
568

A
DIV A
01
593
598


select section, section_name, section_id,
       group_concat(min_sr, '-', max_sr order by min_sr separator ', ')
from (select section, section_name, section_id,
             min(student_rollno) as min_sr, max(student_rollno) as max_sr
      from (select cr.*,
                   row_number() over (partition by section, section_name, section_id order by student_rollno) as seqnum
            from class_room cr
           ) cr
      group by section, section_name, section_id, (student_rollno - seqnum)
     ) ss
group by section, section_name, section_id


section
section_name
section_id
group_concat(min_sr, '-', max_sr order by min_sr separator ', ')


A
DIV A
01
547-552, 567-568, 593-598


select section, section_name, section_id,
       group_concat(min_sr, '-', max_sr order by min_sr separator ', ')
from (select section, section_name, section_id,
             min(student_rollno) as min_sr, max(student_rollno) as max_sr
      from (select cr.*, (@rn := @rn + 1) as seqnum
            from (select cr.*
                  from class_room cr
                  order by section, section_name, section_id, student_rollno
                 ) cr cross join
                 (select @rn := 0) params
           ) cr
      group by section, section_name, section_id, (student_rollno - seqnum)
     ) ss
group by section, section_name, section_id


section
section_name
section_id
group_concat(min_sr, '-', max_sr order by min_sr separator ', ')


A
DIV A
01
547-552, 567-568, 593-598