BUG: Avoid RangeIndex conversion in read_csv if dtype is specified
- [x] closes #59077 (Replace xxxx with the GitHub issue number)

No whatsnew needed since a it's a bug on main
Going to merge since this fixes the bug on main. Happy to follow up if needed