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
