The SCUBA-2 Cosmology Legacy Survey: galaxies in the deep 850 μm survey, and the star-forming `main sequence'