MySQL 8.0

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

create table `trips` (
    tripId int,
    carId int
)
insert into trips
values
(1,147),
(1,62),
(1,59),
(1,42);
SELECT * 
FROM `trips` 
WHERE (   carId = 147 
       OR carId = 62 
       OR carId = 59 
       OR carId = 42) 
LIMIT 50


tripId
carId


1
147

1
62

1
59

1
42