The editor of a Scottish newspaper has apologised for a controversial front-page image that leaned on "lazy stereotypes" in the days before the Euro 2024 final.