Gen X and Millennials are driving a massive shift into self-managed super, pushing the sector to a record 680,000 funds holding more than $1.1 trillion.