The faint radio source population at 15.7 GHz – II. Multi-wavelength properties