Support the wacky prefixes in CDS unit format

This is an alternative to #1172, in which prefixes on units that don't usually have them are supported by the CDS parser (since CDS requires it).  Unlike #1172, this does not add those prefixed units to the astropy.units namespace.

Fix #1169 (the original issue).