A long-awaited new multimillion pound railway station on the mainline in Rotherham is expected to open by 2031, as plans have taken a step forward.