Yes, it can be used with MacBook devices as long as a free USB 3.0 or USB-C port is available. However, it only supports CD and DVD media, not Blu-ray.
I always press the switch to open the drive. Don't know if it would open automatically. Otherwise, right-click on the drive on the PC, maybe there is Open or something like that.