MySQL 5.7

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

create table `trips` (
    tripId int,
    carId int,
    distance int,
    comment varchar(50)
)
insert into trips
values
(1,147,500, 'Trip distance 500'),
(1,62,700, 'Trip distance 700'),
(4,59,20, 'Trip distance 20'),
(1,59,320, 'Trip distance 320'),
(1,59,410, 'Trip distance 410'),
(1,42,100, 'Trip distance 100'),
(1,42,400, 'Trip distance 400'),
(111,42,800, 'Trip distance 800'),
(14,42,100, 'Trip distance 100'),
(1,147,600, 'Trip distance 600'),
(14,147,900, 'Trip distance 900'),
(7,147,2000, 'Trip distance 2000'),
(3,59,11, 'Trip distance 11'),
(11,59,34, 'Trip distance 34'),
(8,59,300, 'Trip distance 300'),
(1,59,2000, 'Trip distance 2000'),
(3,147,225, 'Trip distance 255'),
(8,147,450, 'Trip distance 450'),
(8,59,480, 'Trip distance 480'),
(111,59,300, 'Trip distance 300'),
(1,42,1800, 'Trip distnace 1800');

Records: 21  Duplicates: 0  Warnings: 0


SELECT * 
FROM `trips` 
WHERE (   carId = 147 
       OR carId = 62 
       OR carId = 59 
       OR carId = 42 ) AND distance < 1001
LIMIT 8


tripId
carId
distance
comment


1
147
500
Trip distance 500

1
62
700
Trip distance 700

4
59
20
Trip distance 20

1
59
320
Trip distance 320

1
59
410
Trip distance 410

1
42
100
Trip distance 100

1
42
400
Trip distance 400

111
42
800
Trip distance 800

tripId	carId	distance	comment
1	147	500	Trip distance 500
1	62	700	Trip distance 700
4	59	20	Trip distance 20
1	59	320	Trip distance 320
1	59	410	Trip distance 410
1	42	100	Trip distance 100
1	42	400	Trip distance 400
111	42	800	Trip distance 800