Sample

        $prods = $prods->orderBy(DB::raw('field(a.id, ' . implode(', ', $final_arr) . ')'))
            ->skip($skip)
            ->take($take)
            ->get();

Reference

1. https://stackoverflow.com/questions/8055138/mysql-sort-order-by-array-value
2. https://dev.mysql.com/doc/refman/8.0/en/string-functions.html#function_field
3. Could be replaced with orderRaw()
   https://laravel.com/docs/8.x/queries