MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE odds_op (`id_` INTEGER, `match_op_id` INTEGER, `version` INTEGER, `p1` INTEGER);

INSERT INTO odds_op (`id_`, `match_op_id`, `version`, `p1`) VALUES
  ('1', '1', '1', '1'),
  ('2', '1', '1', '5'),
  ('3', '1', '2', '3'),
  ('4', '1', '2', '4'),
  ('5', '2', '1', '1'),
  ('6', '2', '1', '5'),
  ('7', '2', '2', '3'),
  ('8', '2', '2', '4'),
  ('9', '2', '2', '4');
SELECT o1.match_op_id, MAX(o1.p1) p1
FROM odds_op o1
WHERE NOT EXISTS (
  SELECT 1 
  FROM odds_op o2 
  WHERE o2.match_op_id = o1.match_op_id AND o2.version > o1.version
)
GROUP BY o1.match_op_id


match_op_id
p1


1
4

2
4


SELECT o1.match_op_id, MAX(o1.p1) p1
FROM odds_op o1
WHERE o1.version = (SELECT MAX(o2.version) FROM odds_op o2 WHERE o2.match_op_id = o1.match_op_id)
GROUP BY o1.match_op_id


match_op_id
p1


1
4

2
4


SELECT DISTINCT match_op_id,
       FIRST_VALUE(p1) OVER (PARTITION BY match_op_id ORDER BY version DESC, p1 DESC) p1
FROM odds_op


match_op_id
p1


1
4

2
4