SELECT
  r.region_id,
  r.name
FROM regions AS r
ORDER BY r.name;