MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE IF NOT EXISTS `mytable` (
  `id` int AUTO_INCREMENT,
  `year` int,
  `msg` varchar(20),
  PRIMARY KEY (`id`)
) DEFAULT CHARSET=utf8;
INSERT INTO mytable (year, msg) VALUES
  (2021, "C"), (2020, "B"), (2020, "A"), (2020, "D"), (2021, "E");
SELECT
  t.id,
  year,
  msg
FROM
  (SELECT
     ROW_NUMBER() OVER(ORDER BY id ASC) AS num_row,
     id
   FROM mytable
   WHERE year = 2020
  ) t
JOIN mytable ON mytable.id = t.id
WHERE num_row IN (1, 3)


id
year
msg


2
2020
B

4
2020
D