Reallow usecols to reference OOB indices - reverts 25623
- [x] closes #27252
reverts #25623

@heckeop 

@gfyoung I know you asked for a FutureWarning to be raised but I didn't want to mess around with the validation_function in place here so just did a simple revert for sake of time / effort

@WillAyd : I think it's fine to revert in this PR, but I would investigate adding a warning in a follow-up. thanks @WillAyd  may need to reopen the original issue?