All EF lenses manufactured since 1987 will work on all EF mount EOS SLR cameras made by Canon since 1987 when the EOS system was introduced.

This includes all film EOS SLR cameras and all digital EOS SLR cameras including all DSLR models with full frame, APS-H, and APS-C size sensors.

EF-S lenses will only work on EOS DSLR cameras with APS-C sized sensors. Since your EOS Rebel SL3/250D has an APS-C size sensor, it can use every single EF and EF-S lens Canon has ever made. Every.Single.One.

Whether the EF 100mm f/2.8L IS Macro is the best choice for your purposes is another question.

The EF 100mm f/2.8L IS Macro is a bit more expensive than the EF 100mm f/2.8 Macro. Optically they perform very similarly. The advantage of the "L" lens is mainly that is has image stabilization (IS) and a higher level of build quality. If you're going to be using a tripod (as you almost certainly should for product/food photography), then you'd be paying for IS that you don't need, since you'll turn it off when using a tripod. Unless you're going to put the lens through a meat grinder day in and day out in all kinds of shooting conditions (weather, industrial settings, steamy kitchens, etc.), for you the build quality probably won't be something worth paying extra for, either.

If by "food photography" you mean taking pictures of your plate before you eat in a restaurant's dining room during the restaurant's normal operating hours, then 100mm will be entirely too long for that unless the people at the table next to yours don't mind you standing on top of their table to frame your plate with an APS-C camera. You'd be better served by something that includes focal lengths in the 18mm to 35mm range.