PERF: Allow ensure_index_from_sequence to return RangeIndex
Discovered in https://github.com/pandas-dev/pandas/pull/57441

Builds on https://github.com/pandas-dev/pandas/pull/57752

Any other comments here @WillAyd? Nope all good. And thanks for the ping - sorry sometimes fall behind on notifications