Hidden magnetism uncovered in charge ordered bilayer kagome material ScV_6Sn_6