Magnetic structure of light nuclei from lattice QCD