Create a `FindScikitBuildCore.cmake` module

[LecrisUT]

There could be some additional checks and settings that would work better running within CMake, e.g. checking try_compile of python bindings. What can or should include in such a module:

• check that scikit-build-core is included in the python environment
• expose Components to control additional integrations
• try_compile to make sure python devel package is present and ABI compatible with the compiler
• migrate most cache values definitions to there
• expose functions to create and install python metadata files, python native files, etc.
• reconfigure GnuInstallDir paths to be wheel install compatible. Primarily thinking about CMAKE_INSTALL_BINDIR

Most of these should be gated by the components requested and maybe pip install can auto-inject some components depending on the configuration.