i'm working with windows --> no know how about apple

If the Macbook Air has a normal USB port, yes, that would work, the Apple Macbook doesn't care so much that an Apple DVD burner is plugged in, it also manages with a Lenovo DVD burner.

What would be the point if a DVD drive could not play DVDs?

Hello. The drive is connected and powered via the USB3.0 interface. Cable is included.