Laravel data filtering and sorting with pagination

I am developing a laravel project which has a function to search tournaments. it has a view to list all tournaments. then it has functionalities to search by id, name, category etc. i want to sort this list A-Z with filtered results also. how can I do that?table has over 1 million records.when i user orderBy('table.name','asc'), it takes a lot time. this query uses paginate as well.what would be the best practice to do this?

via Chebli Mohamed