I want to select 3 specific record and the rest should be random.
You can achieve this with the help of
CASE WHEN and
SELECT * FROM table_jess ORDER BY CASE WHEN FIND_IN_SET(id,'2,5,8') > 0 THEN 0 ELSE id END,id
Please check the WORKING DEMO
If you want random result for the rest of the entries then use the following query:
SELECT * FROM table_jess ORDER BY CASE WHEN FIND_IN_SET(id,'8,2,5') > 0 THEN 0 ELSE RAND() END,id;