DELETE FROM `gps`
WHERE id NOT IN (
  SELECT id
  FROM (
    SELECT id
    FROM `gps`
    ORDER BY id DESC
    LIMIT 200
  ) foo
);