Lucknow Super Giants pulled off a stunning two-run win against Kolkata Knight Riders in a last-ball thriller to qualify for playoffs of the Indian Premier League 2022.