Can I distribute App Store apps to iPhone/iPad/Apple TV without requiring an Apple ID sign-in?

Yes, you can by using VPP in Apple Business (formerly Apple Business Manager).

For details on VPP, see the following page.
What is VPP?