Cardiff City secured League One promotion in dramatic fashion after a late goal elsewhere sparked jubilant scenes among fans in Reading.