SELECT distinct geo_cities.id FROM geo_cities, puppy_listings WHERE geo_cities.city_id = puppy_listings.city_id ORDER BY geo_cities.city_name ASC

distinct устранит дубликаты в выводе