RFE: Honor MODULES_AUTO_HANDLING

[opoplawski]

Describe the bug
TCL Environment Modules has a MODULES_AUTO_HANDLING environment variable described here:
https://modules.readthedocs.io/en/latest/module.html#envvar-MODULES_AUTO_HANDLING

It would be helpful if Lmod supported it.

To Reproduce

export MODULES_AUTO_HANDLING=1
ml intel/2024.0.0
Lmod has detected the following error: Cannot load module "compiler/2024.0.0". At least one of
these module(s) must be loaded:
   tbb

While processing the following module(s):
    Module fullname    Module Filename
    ---------------    ---------------
    compiler/2024.0.0  /opt/ohpc/pub/moduledeps/oneapi/compiler/2024.0.0
    intel/2024.0.0     /opt/ohpc/pub/modulefiles/intel/2024.0.0

Expected behavior
The prereqs for intel/2024.0.0 are loaded automatically.

Desktop (please complete the following information):

• OS: Linux
• Linux distribution: AlmaLinux 8.9
• Lmod Version: 8.7.32
• For Lmod Versions 8.7.7+, please run "module --miniConfig" and
  include the output here.

Modules based on Lua: Version 8.7.32  2023-08-28 12:42 -05:00
    by Robert McLay mclay@tacc.utexas.edu

Changes from Default Configuration
----------------------------------

Name                         Where Set  Default                                              Value
----                         ---------  -------                                              -----
LFS_VERSION                  D          1.6.3                                                1.8.0
LMOD_AUTO_SWAP               C          yes                                                  no
LMOD_COLORIZE                E          yes                                                  no
LMOD_PACKAGE_PATH            D          nil                                                  <empt
y>
LMOD_PAGER                   C          less                                                 /usr/
bin/more
LMOD_REDIRECT                C          no                                                   yes
LMOD_SITEPACKAGE_LOCATION    Other      /opt/ohpc/admin/lmod/8.7.32/libexec/SitePackage.lua  <srct
ree>
LMOD_SYSTEM_DEFAULT_MODULES  D          __unknown__                                          <empt
y>
LMOD_TCLSH                   C          tclsh                                                /usr/
bin/tclsh
MODULEPATH_ROOT              C                                                               /opt/
ohpc/admin/modulefiles
PATH_TO_LUA                  C          lua                                                  /usr/
bin/lua


Where Set -> D: default, E: environment, C: configuration
             lmod_cfg: lmod_config.lua SitePkg: SitePackage StdPkg: StandardPackage
             Other: Set somewhere outside of normal locations

Additional context
Intel changed they way they are expressing module deps - see https://community.intel.com/t5/Intel-oneAPI-Base-Toolkit/Why-the-change-to-module-prerequisites-with-2024-compiler/m-p/1550044