Scotland’s First Minister has urged Rishi Sunak to secure a deal to join a top European research programme as an agreement inches closer.