SELECT `location`.`id`
FROM `ad_offer` `offer`
JOIN `location` ON `location`.`id` = `offer`.`location_id`
GROUP BY `location`.`id`
ORDER BY `location`.`location` ASC