Real Madrid beat Valencia 4-2 in the second leg of the Spanish Super Cup to lift the trophy for the eighth time in their history.