SNP Westminster leader Stephen Flynn will no longer seek a dual mandate to stand as an MSP in the Scottish parliament while remaining an MP.