 BUG: fix numpy min/max compat with index (#26125)
- [x] closes #26125
- [x] 2 tests added
- [x] passes `git diff upstream/master -u -- "*.py" | flake8 --diff`
- [x] whatsnew entry


When working on the original issue, I came across something similar :
- `RangeIndex` had its own implementation of `max`/`min` with the same behavior
- `Index` & `RangeIndex` could both benefit from adding another compat call

```
In [5]: np.argmin(pd.Index([1,2,3]), out=0)
---------------------------------------------------------------------------
TypeError                                 Traceback (most recent call last)
venv\lib\site-packages\numpy\core\fromnumeric.py in _wrapfunc(obj, method, *args, **kwds)
     55     try:
---> 56         return getattr(obj, method)(*args, **kwds)
     57

TypeError: argmin() got an unexpected keyword argument 'out'

During handling of the above exception, another exception occurred:

TypeError                                 Traceback (most recent call last)
<ipython-input-5-5c9b894867ef> in <module>
----> 1 np.argmin(pd.Index([1,2,3]), out=0)

venv\lib\site-packages\numpy\core\fromnumeric.py in argmin(a, axis, out)
   1170
   1171     """
-> 1172     return _wrapfunc(a, 'argmin', axis=axis, out=out)
   1173
   1174

venv\lib\site-packages\numpy\core\fromnumeric.py in _wrapfunc(obj, method, *args, **kwds)
     64     # a downstream library like 'pandas'.
     65     except (AttributeError, TypeError):
---> 66         return _wrapit(obj, method, *args, **kwds)
     67
     68

venv\lib\site-packages\numpy\core\fromnumeric.py in _wrapit(obj, method, *args, **kwds)
     44     except AttributeError:
     45         wrap = None
---> 46     result = getattr(asarray(obj), method)(*args, **kwds)
     47     if wrap:
     48         if not isinstance(result, mu.ndarray):

TypeError: output must be an array
```
I changed it to be consistent with the rest of pandas `ValueError: the 'out' parameter is not supported in the pandas implementation of argmax()`.

