Performance hit with limit query on large dataset

PHP Code:

$query = $this->db->query('
  SELECT id, name, address, phone
  FROM customers
  INNER JOIN (
  SELECT id
  FROM customers
  ORDER BY name
  LIMIT 10 OFFSET 9950)
  AS my_results USING(id);
'); 


Expert Website Development - Temecula, CA
Community Auth For CodeIgniter 3