MySQL 5.7

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

CREATE TABLE table1 ( field1 int ,field2 int)
INSERT INTO table1 VALUES(4,2),(4,2),(4,2),(4,2),(4,2),(4,3),(4,3),(4,3),(4,3),(4,4)
SELECT * FROM 
(SELECT 
field1,
  IF (@field2 = field2 ,@row_number :=  @row_number + 1,@row_number := 1) AS rn,
    @field2 := field2 field2
FROM
    (SELECT * FROM table1 where field1 = 4 and field2 in (2,3,4,5) ORDER BY field2) t1,
    (SELECT @field2:=0,@row_number:=0) as t ) t2
    WHERE rn <= 4


field1
rn
field2


4
1
2

4
2
2

4
3
2

4
4
2

4
1
3

4
2
3

4
3
3

4
4
3

4
1
4