“There’s no tanks, fantastical swordfights or bloody executions, just sweat, songs and almighty sing-alongs: rock’n’roll at its very best.” Foo Fighters return to their punk roots in a very sweaty Manchester club