The case that can support auto-turn-on afaik Is the Smart Keyboard Folio case. I never use that feature cause I want to let iPad doing something without turning the screen off, for example let game run in the background.
There’s another cover designed for cheaper iPad that has that feature.