The optical spectra of spitzer 24 μm galaxies in the cosmic evolution survey field. II. Faint infrared sources in the zCosmos-Bright 10k catalog