upstart script feels a bit wrong place to do it for me. You could write a desktop file that has the mplayer launch command in the exec line and put the created desktop file in /etc/xdg/autostart/

You can take an existing one from /usr/share/applications/hildon/ and modify it. info about desktop files: http://wiki.maemo.org/Desktop_file_format