it's on stockport road and is only 3/4 mile from Piccadilly station so you could walk; or take a 192 bus from outside the station or Piccadilly Gardens (in the city centre). A cab will cost you �3.
the last 192 bus passes the apollo around midnight (except on thursdays, when there are a few later ones) - they are about every 10 minutes, even in the evening.