Shaheen Afridi claimed six wickets, including four in four balls, as Hampshire secured a final Vitality Blast victory of the 2020 summer against Middlesex at the Ageas Bowl.