The Macintosh is not emulating a SCSI controller. The CDROM.SYS CD-ROM driver is not really a SCSI driver, it simply reroutes certain CDROM calls from the DOS side to the Macintosh cdrom drive. Apple wrote CDROM.SYS specifically to reroute the calls. A standard MS-DOS CD-ROM driver will not work, because it is not written to reroute the calls to the Apple CD-ROM extension.
You may be able to use parts of a CD-ROM disc by using the folder sharing feature on the CD-ROM. This is the only way to use non-Apple CD-ROM drives unless the vendor creates a specific DOS driver to transfer CD-ROM calls from the DOS side to the third-party CD-ROM driver on the Macintosh side.
Support Information Services