Struggling Huddersfield produced a sensational performance to defeat Betfred Super League leaders Wigan 34-16 at the Brick Community Stadium.