How to fetch records from mysql database in sorted order with pagination along with group by status

You just need descendingly sort by is_active column, and no need an OFFSET value depending on the explanation such as

SELECT * 
  FROM employee 
 ORDER BY is_active DESC, name 
 LIMIT 10