MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table myrealtable(id int, starttime datetime, endtime datetime);
insert into myrealtable values (0,	'2022-06-10 12:44:55','2022-06-10 12:46:55');
insert into myrealtable values (1,	'2022-06-10 12:47:55','2022-06-10 12:48:55');
insert into myrealtable values (2,	'2022-06-10 12:49:00','2022-06-10 12:50:00');
insert into myrealtable values (0,	'2022-06-10 12:45:55','2022-06-10 12:48:55');
 WITH mytable AS
 (
  SELECT row_number() OVER () rid, id, starttime, endtime
  FROM myrealtable
 )
 SELECT distinct id
    FROM mytable mt1
    WHERE exists
     (SELECT *
      FROM mytable mt2
      WHERE mt2.id = mt1.id 
       AND mt2.rid <> mt1.rid
       AND mt2.starttime >= mt1.starttime and mt2.starttime < mt1.endtime)
    OR exists 
    (SELECT *
     FROM mytable mt2
     WHERE mt2.id = mt1.id 
      AND mt2.rid <> mt1.rid
      AND mt2.endtime > mt1.starttime and mt2.endtime <= mt1.endtime)


id


0


    WITH mytable AS
     (
      SELECT row_number() OVER () rid, id, starttime, endtime
      FROM myrealtable
     )
    SELECT distinct mt1.id
    FROM mytable mt1 INNER JOIN mytable mt2
      ON mt2.id = mt1.id and mt2.rid <> mt1.rid
    WHERE (mt2.starttime >= mt1.starttime and mt2.starttime < mt1.endtime)
     OR (mt2.endtime > mt1.starttime and mt2.endtime <= mt1.endtime)


id


0