A man wanted by police over an alleged cold case murder in Queensland has been arrested in Sydney after a national manhunt.